Disclaimer

The mentioned functionalities may be restricted depending on the purchased software license.

How to Add Historical Data

To upload historical data, you need to format your Excel sheet correctly. This guide explains the required columns and formats.

Required Columns

Your file must contain the following required columns:

1. ID

   • Indicates the installation or inverter ID for which a data point should be added.
   • Find the ID in the installation overview (hidden by default, but can be enabled).
   • IDs are unique to prevent confusion.

2. Time

   • Specifies the timestamp of the data point.
   • Accepted formats:
     • "YYYY-MM-DDTHH:MMZ" (e.g., "2022-02-01T08:00:00") – Includes time zone.
     • "YYYY-MM-DD" (e.g., "2022-02-01") – Assumes midnight (00:00:00).
   • If either the ID or Time column is missing, the file will not be processed.

Optional Columns

You may also include the following columns:

• Timezone

  • The time zone for the data point.
  • Use a valid TZ database name (e.g., "Europe/Amsterdam" or "UTC").
  • If unspecified, UTC is assumed.

• actualPower_W

  • The power (Watts) of the entity at the specified time.
  • Must use decimal notation (e.g., "15000.001", not "15 000.001").

• energyDelta_Wh

  • The energy (Wh) produced since the last recorded data point.
  • Shown in bar charts and heat maps in the dashboard.
  • Uses decimal notation.

Additional Optional Data

For a more detailed dataset, you can include:

• Voltages (in Volts)

  • "voltage_V" (single-phase)
  • "voltageL1L2_V", "voltageL1L3_V", "voltageL2L3_V" (three-phase)
  • "voltageL1N_V", "voltageL2N_V", "voltageL3N_V" (voltage differences with neutral)

• Current (in Amps)

  • "current_A" (single-phase)
  • "currentL1_A", "currentL2_A", "currentL3_A" (three-phase)

• Temperature (in Celsius)

  • "temperature_C"

---

Example Table Structure

ID	time	timezone	actualPower_W	energyDelta_Wh	temperature_C
123	2022-02-01T08:00:00Z	UTC	15000.001	500.2	25.0
124	2022-02-01T08:15:00Z	Europe/Amsterdam	14800.750	490.0	24.8

Indien een bepaalde ID+time combinatie meerdere keren voorkomt, worden de inhouden van de kolommen samen genomen, en wordt steeds de laatst gespecificeerde waarde voor een kolom genomen

Download Example Excel Sheet